pg_hba.conf change in 7.4 - Mailing list pgsql-general

From Seum-Lim Gan
Subject pg_hba.conf change in 7.4
Date
Msg-id p05100300bbe295614d7e@[135.185.171.70]
Whole thread Raw
Responses Re: pg_hba.conf change in 7.4  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Hi,

In 7.4, I noticed there is this ::1 and ffff: (x8 of them)
for IPv6.

I looked at the documentation and there is nothing that says
what the ::1 is for.

Commenting out that line will prevent access to PostgreSQL
from psql unless I put trust for that line.

This is what I had in 7.3.4:
host    all         all         127.0.0.1         255.255.255.255
ident pspmap
local   all         all                                             password
host    all         all         0.0.0.0        0.0.0.0          reject

But in 7.4, it does not work anymore. It seems to want ::1 to be somewhere.
If I change the line with ::1 from trust to ident pspmap, it complains that
the user cannot be found. But it is in the pspmap. Message fromm psql:

    psql: FATAL:  IDENT authentication failed for user "postgres"

Right now, I have it set to trust to work around.
Any idea what to do about this ?

host    all         all         127.0.0.1         255.255.255.255
ident pspmap
local   all         all                                             password
host    all         all         0.0.0.0        0.0.0.0          reject
# IPv4-style local connections:
#host    all         all         127.0.0.1         255.255.255.255   trust
# IPv6-style local connections:
host    all         all         ::1
ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        trust

Thanks.

Gan
--
+--------------------------------------------------------+
| Seum-Lim GAN                 email : slgan@lucent.com  |
| Lucent Technologies                                    |
| 2000 N. Naperville Road, 6B-403F  tel : (630)-713-6665 |
| Naperville, IL 60566, USA.        fax : (630)-713-7272 |
|       web : http://inuweb.ih.lucent.com/~slgan         |
+--------------------------------------------------------+

pgsql-general by date:

Previous
From: "Durai"
Date:
Subject: Multiuser testing -- PostgreSQL 7.3.4
Next
From: "Durai"
Date:
Subject: Re: error durring compilation